<?php
/**
 * Created by PhpStorm.
 * User: jade
 * Date: 2014-11-19
 * Time: 오전 11:15
 */
/*
phpinfo();
exit;
*/
include("./inc/conn.inc.php");

//declare the SQL statement that will query the database
$query = "SELECT weight, zone01 ";
$query .= "FROM tblRateExpress ";


//execute the SQL query and return records
$result = mssql_query($query);

$numRows = mssql_num_rows($result);
echo "<h1>" . $numRows . " Row" . ($numRows == 1 ? "" : "s") . " Returned </h1>";

//display the results
while($row = mssql_fetch_array($result))
{
    echo "<li>" . $row["weight"] ." : " . $row["zone01"]  . "</li>";
}
//close the connection
mssql_close($dbhandle);